Dataset statistics
| Number of variables | 31 |
|---|---|
| Number of observations | 9082 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 1.7 MiB |
| Average record size in memory | 200.0 B |
Variable types
| BOOL | 15 |
|---|---|
| NUM | 11 |
| CAT | 5 |
Reproduction
| Analysis started | 2021-04-21 15:00:26.926329 |
|---|---|
| Analysis finished | 2021-04-21 15:01:50.665286 |
| Duration | 1 minute and 23.74 seconds |
| Version | pandas-profiling v2.8.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
Provider Name has a high cardinality: 212 distinct values | High cardinality |
Provider City has a high cardinality: 100 distinct values | High cardinality |
Total Number of Occupied Beds is highly correlated with Number of All Beds | High correlation |
Number of All Beds is highly correlated with Total Number of Occupied Beds | High correlation |
Week Ending is uniformly distributed | Uniform |
Provider Name is uniformly distributed | Uniform |
Residents Total Admissions COVID-19 has 1980 (21.8%) zeros | Zeros |
Residents Total Confirmed COVID-19 has 1362 (15.0%) zeros | Zeros |
Residents Total Suspected COVID-19 has 2621 (28.9%) zeros | Zeros |
Residents Weekly All Deaths has 5784 (63.7%) zeros | Zeros |
Residents Total All Deaths has 361 (4.0%) zeros | Zeros |
Residents Total COVID-19 Deaths has 2087 (23.0%) zeros | Zeros |
Staff Total Confirmed COVID-19 has 827 (9.1%) zeros | Zeros |
Staff Weekly Suspected COVID-19 has 8549 (94.1%) zeros | Zeros |
Staff Total Suspected COVID-19 has 2797 (30.8%) zeros | Zeros |
| Distinct count | 43 |
|---|---|
| Unique (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 71.0 KiB |
| 2020-09-06T00:00:00 | 212 |
|---|---|
| 2020-06-28T00:00:00 | 212 |
| 2020-08-16T00:00:00 | 212 |
| 2020-07-05T00:00:00 | 212 |
| 2020-05-31T00:00:00 | 212 |
| Other values (38) |
| Value | Count | Frequency (%) | |
| 2020-09-06T00:00:00 | 212 | 2.3% | |
| 2020-06-28T00:00:00 | 212 | 2.3% | |
| 2020-08-16T00:00:00 | 212 | 2.3% | |
| 2020-07-05T00:00:00 | 212 | 2.3% | |
| 2020-05-31T00:00:00 | 212 | 2.3% | |
| 2020-09-13T00:00:00 | 212 | 2.3% | |
| 2020-09-20T00:00:00 | 212 | 2.3% | |
| 2020-08-23T00:00:00 | 212 | 2.3% | |
| 2020-09-27T00:00:00 | 212 | 2.3% | |
| 2020-07-19T00:00:00 | 212 | 2.3% | |
| Other values (33) | 6962 | 76.7% |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
| Distinct count | 212 |
|---|---|
| Unique (%) | 2.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 71.0 KiB |
| CHESTERFIELDS HEALTH CARE CENTER | 43 |
|---|---|
| CAMBRIDGE HEALTH AND REHABILITATION CENTER | 43 |
| SPRINGS AT WATERMARK EAST HILL, THE | 43 |
| HARRINGTON COURT | 43 |
| LIVEWELL CONNECTICUT | 43 |
| Other values (207) |
| Value | Count | Frequency (%) | |
| CHESTERFIELDS HEALTH CARE CENTER | 43 | 0.5% | |
| CAMBRIDGE HEALTH AND REHABILITATION CENTER | 43 | 0.5% | |
| SPRINGS AT WATERMARK EAST HILL, THE | 43 | 0.5% | |
| HARRINGTON COURT | 43 | 0.5% | |
| LIVEWELL CONNECTICUT | 43 | 0.5% | |
| BISHOP WICKE HEALTH & REHAB CT | 43 | 0.5% | |
| APPLE REHAB COLCHESTER | 43 | 0.5% | |
| ESSEX MEADOWS HEALTH CENTER | 43 | 0.5% | |
| CHESTELM HEALTH CARE | 43 | 0.5% | |
| MERIDEN CENTER | 43 | 0.5% | |
| Other values (202) | 8652 | 95.3% |
Length
| Max length | 50 |
|---|---|
| Median length | 26 |
| Mean length | 27.03501431 |
| Min length | 7 |
| Distinct count | 100 |
|---|---|
| Unique (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 71.0 KiB |
| WATERBURY | 334 |
|---|---|
| MERIDEN | 301 |
| DANBURY | 215 |
| WEST HARTFORD | 215 |
| STAMFORD | 215 |
| Other values (95) |
| Value | Count | Frequency (%) | |
| WATERBURY | 334 | 3.7% | |
| MERIDEN | 301 | 3.3% | |
| DANBURY | 215 | 2.4% | |
| WEST HARTFORD | 215 | 2.4% | |
| STAMFORD | 215 | 2.4% | |
| NEW HAVEN | 215 | 2.4% | |
| NEW BRITAIN | 215 | 2.4% | |
| MIDDLETOWN | 172 | 1.9% | |
| TORRINGTON | 172 | 1.9% | |
| HAMDEN | 172 | 1.9% | |
| Other values (90) | 6856 | 75.5% |
Length
| Max length | 16 |
|---|---|
| Median length | 9 |
| Mean length | 8.759083902 |
| Min length | 4 |
| Distinct count | 196 |
|---|---|
| Unique (%) | 2.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.213279013433164 |
|---|---|
| Minimum | 0 |
| Maximum | 535 |
| Zeros | 1980 |
| Zeros (%) | 21.8% |
| Memory size | 35.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 6 |
| Q3 | 17 |
| 95-th percentile | 56 |
| Maximum | 535 |
| Range | 535 |
| Interquartile range (IQR) | 16 |
Descriptive statistics
| Standard deviation | 31.65158627 |
|---|---|
| Coefficient of variation (CV) | 2.080523617 |
| Kurtosis | 74.6270188 |
| Mean | 15.21327901 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 6.898305587 |
| Sum | 138167 |
| Variance | 1001.822914 |
| Value | Count | Frequency (%) | |
| 0 | 1980 | 21.8% | |
| 1 | 902 | 9.9% | |
| 2 | 491 | 5.4% | |
| 4 | 461 | 5.1% | |
| 7 | 373 | 4.1% | |
| 10 | 357 | 3.9% | |
| 6 | 332 | 3.7% | |
| 5 | 310 | 3.4% | |
| 3 | 296 | 3.3% | |
| 8 | 271 | 3.0% | |
| Other values (186) | 3309 | 36.4% |
| Value | Count | Frequency (%) | |
| 0 | 1980 | 21.8% | |
| 1 | 902 | 9.9% | |
| 2 | 491 | 5.4% | |
| 3 | 296 | 3.3% | |
| 4 | 461 | 5.1% |
| Value | Count | Frequency (%) | |
| 535 | 1 | < 0.1% | |
| 528 | 1 | < 0.1% | |
| 521 | 1 | < 0.1% | |
| 513 | 1 | < 0.1% | |
| 494 | 1 | < 0.1% |
| Distinct count | 159 |
|---|---|
| Unique (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 37.77659105923805 |
|---|---|
| Minimum | 0 |
| Maximum | 171 |
| Zeros | 1362 |
| Zeros (%) | 15.0% |
| Memory size | 35.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 4 |
| median | 28 |
| Q3 | 63 |
| 95-th percentile | 102 |
| Maximum | 171 |
| Range | 171 |
| Interquartile range (IQR) | 59 |
Descriptive statistics
| Standard deviation | 35.79671296 |
|---|---|
| Coefficient of variation (CV) | 0.9475898156 |
| Kurtosis | 0.06923640367 |
| Mean | 37.77659106 |
| Median Absolute Deviation (MAD) | 27 |
| Skewness | 0.8418299912 |
| Sum | 343087 |
| Variance | 1281.404658 |
| Value | Count | Frequency (%) | |
| 0 | 1362 | 15.0% | |
| 1 | 399 | 4.4% | |
| 2 | 235 | 2.6% | |
| 3 | 197 | 2.2% | |
| 5 | 190 | 2.1% | |
| 18 | 165 | 1.8% | |
| 28 | 163 | 1.8% | |
| 20 | 161 | 1.8% | |
| 23 | 144 | 1.6% | |
| 17 | 132 | 1.5% | |
| Other values (149) | 5934 | 65.3% |
| Value | Count | Frequency (%) | |
| 0 | 1362 | 15.0% | |
| 1 | 399 | 4.4% | |
| 2 | 235 | 2.6% | |
| 3 | 197 | 2.2% | |
| 4 | 107 | 1.2% |
| Value | Count | Frequency (%) | |
| 171 | 2 | < 0.1% | |
| 170 | 15 | 0.2% | |
| 169 | 1 | < 0.1% | |
| 168 | 1 | < 0.1% | |
| 167 | 1 | < 0.1% |
| Distinct count | 107 |
|---|---|
| Unique (%) | 1.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.439440651838803 |
|---|---|
| Minimum | 0 |
| Maximum | 293 |
| Zeros | 2621 |
| Zeros (%) | 28.9% |
| Memory size | 35.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 3 |
| Q3 | 18 |
| 95-th percentile | 69 |
| Maximum | 293 |
| Range | 293 |
| Interquartile range (IQR) | 18 |
Descriptive statistics
| Standard deviation | 32.80970818 |
|---|---|
| Coefficient of variation (CV) | 2.125058085 |
| Kurtosis | 30.82677992 |
| Mean | 15.43944065 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 4.812728346 |
| Sum | 140221 |
| Variance | 1076.476951 |
| Value | Count | Frequency (%) | |
| 0 | 2621 | 28.9% | |
| 1 | 1071 | 11.8% | |
| 2 | 598 | 6.6% | |
| 3 | 517 | 5.7% | |
| 4 | 287 | 3.2% | |
| 6 | 272 | 3.0% | |
| 5 | 213 | 2.3% | |
| 20 | 200 | 2.2% | |
| 7 | 182 | 2.0% | |
| 21 | 178 | 2.0% | |
| Other values (97) | 2943 | 32.4% |
| Value | Count | Frequency (%) | |
| 0 | 2621 | 28.9% | |
| 1 | 1071 | 11.8% | |
| 2 | 598 | 6.6% | |
| 3 | 517 | 5.7% | |
| 4 | 287 | 3.2% |
| Value | Count | Frequency (%) | |
| 293 | 25 | 0.3% | |
| 292 | 12 | 0.1% | |
| 288 | 1 | < 0.1% | |
| 286 | 1 | < 0.1% | |
| 279 | 1 | < 0.1% |
| Distinct count | 44 |
|---|---|
| Unique (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.8313146883946267 |
|---|---|
| Minimum | 0 |
| Maximum | 71 |
| Zeros | 5784 |
| Zeros (%) | 63.7% |
| Memory size | 35.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 3 |
| Maximum | 71 |
| Range | 71 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 2.777344239 |
|---|---|
| Coefficient of variation (CV) | 3.34090601 |
| Kurtosis | 175.2695731 |
| Mean | 0.8313146884 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 11.04748687 |
| Sum | 7550 |
| Variance | 7.71364102 |
| Value | Count | Frequency (%) | |
| 0 | 5784 | 63.7% | |
| 1 | 2033 | 22.4% | |
| 2 | 724 | 8.0% | |
| 3 | 223 | 2.5% | |
| 4 | 104 | 1.1% | |
| 5 | 34 | 0.4% | |
| 6 | 24 | 0.3% | |
| 7 | 24 | 0.3% | |
| 8 | 14 | 0.2% | |
| 10 | 13 | 0.1% | |
| Other values (34) | 105 | 1.2% |
| Value | Count | Frequency (%) | |
| 0 | 5784 | 63.7% | |
| 1 | 2033 | 22.4% | |
| 2 | 724 | 8.0% | |
| 3 | 223 | 2.5% | |
| 4 | 104 | 1.1% |
| Value | Count | Frequency (%) | |
| 71 | 1 | < 0.1% | |
| 66 | 1 | < 0.1% | |
| 56 | 1 | < 0.1% | |
| 52 | 1 | < 0.1% | |
| 51 | 1 | < 0.1% |
| Distinct count | 138 |
|---|---|
| Unique (%) | 1.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.088526756221096 |
|---|---|
| Minimum | 0 |
| Maximum | 196 |
| Zeros | 361 |
| Zeros (%) | 4.0% |
| Memory size | 35.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 9 |
| median | 19 |
| Q3 | 32 |
| 95-th percentile | 61 |
| Maximum | 196 |
| Range | 196 |
| Interquartile range (IQR) | 23 |
Descriptive statistics
| Standard deviation | 20.54581936 |
|---|---|
| Coefficient of variation (CV) | 0.8898713883 |
| Kurtosis | 7.830760268 |
| Mean | 23.08852676 |
| Median Absolute Deviation (MAD) | 11 |
| Skewness | 2.063673226 |
| Sum | 209690 |
| Variance | 422.1306931 |
| Value | Count | Frequency (%) | |
| 0 | 361 | 4.0% | |
| 1 | 343 | 3.8% | |
| 19 | 299 | 3.3% | |
| 3 | 294 | 3.2% | |
| 15 | 254 | 2.8% | |
| 10 | 248 | 2.7% | |
| 2 | 238 | 2.6% | |
| 21 | 237 | 2.6% | |
| 9 | 230 | 2.5% | |
| 11 | 229 | 2.5% | |
| Other values (128) | 6349 | 69.9% |
| Value | Count | Frequency (%) | |
| 0 | 361 | 4.0% | |
| 1 | 343 | 3.8% | |
| 2 | 238 | 2.6% | |
| 3 | 294 | 3.2% | |
| 4 | 220 | 2.4% |
| Value | Count | Frequency (%) | |
| 196 | 1 | < 0.1% | |
| 192 | 1 | < 0.1% | |
| 191 | 2 | < 0.1% | |
| 186 | 1 | < 0.1% | |
| 185 | 1 | < 0.1% |
| Distinct count | 65 |
|---|---|
| Unique (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.087976216692358 |
|---|---|
| Minimum | 0 |
| Maximum | 84 |
| Zeros | 2087 |
| Zeros (%) | 23.0% |
| Memory size | 35.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 7 |
| Q3 | 16 |
| 95-th percentile | 29 |
| Maximum | 84 |
| Range | 84 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 10.92314658 |
|---|---|
| Coefficient of variation (CV) | 1.082788693 |
| Kurtosis | 5.562729679 |
| Mean | 10.08797622 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 1.81117525 |
| Sum | 91619 |
| Variance | 119.3151313 |
| Value | Count | Frequency (%) | |
| 0 | 2087 | 23.0% | |
| 1 | 560 | 6.2% | |
| 7 | 498 | 5.5% | |
| 2 | 365 | 4.0% | |
| 5 | 359 | 4.0% | |
| 6 | 349 | 3.8% | |
| 13 | 342 | 3.8% | |
| 4 | 328 | 3.6% | |
| 9 | 326 | 3.6% | |
| 8 | 299 | 3.3% | |
| Other values (55) | 3569 | 39.3% |
| Value | Count | Frequency (%) | |
| 0 | 2087 | 23.0% | |
| 1 | 560 | 6.2% | |
| 2 | 365 | 4.0% | |
| 3 | 172 | 1.9% | |
| 4 | 328 | 3.6% |
| Value | Count | Frequency (%) | |
| 84 | 5 | 0.1% | |
| 83 | 3 | < 0.1% | |
| 81 | 3 | < 0.1% | |
| 78 | 2 | < 0.1% | |
| 76 | 1 | < 0.1% |
| Distinct count | 92 |
|---|---|
| Unique (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 116.31424796300374 |
|---|---|
| Minimum | 0 |
| Maximum | 360 |
| Zeros | 3 |
| Zeros (%) | < 0.1% |
| Memory size | 35.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 45 |
| Q1 | 76 |
| median | 120 |
| Q3 | 137 |
| 95-th percentile | 217 |
| Maximum | 360 |
| Range | 360 |
| Interquartile range (IQR) | 61 |
Descriptive statistics
| Standard deviation | 55.49257174 |
|---|---|
| Coefficient of variation (CV) | 0.4770917812 |
| Kurtosis | 4.211328111 |
| Mean | 116.314248 |
| Median Absolute Deviation (MAD) | 30 |
| Skewness | 1.533746068 |
| Sum | 1056366 |
| Variance | 3079.425519 |
| Value | Count | Frequency (%) | |
| 120 | 1328 | 14.6% | |
| 60 | 798 | 8.8% | |
| 90 | 588 | 6.5% | |
| 150 | 487 | 5.4% | |
| 130 | 405 | 4.5% | |
| 75 | 258 | 2.8% | |
| 128 | 215 | 2.4% | |
| 160 | 215 | 2.4% | |
| 180 | 172 | 1.9% | |
| 126 | 172 | 1.9% | |
| Other values (82) | 4444 | 48.9% |
| Value | Count | Frequency (%) | |
| 0 | 3 | < 0.1% | |
| 23 | 43 | 0.5% | |
| 25 | 43 | 0.5% | |
| 30 | 86 | 0.9% | |
| 35 | 86 | 0.9% |
| Value | Count | Frequency (%) | |
| 360 | 43 | 0.5% | |
| 357 | 43 | 0.5% | |
| 345 | 43 | 0.5% | |
| 294 | 43 | 0.5% | |
| 282 | 43 | 0.5% |
| Distinct count | 277 |
|---|---|
| Unique (%) | 3.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 85.05450341334507 |
|---|---|
| Minimum | 0 |
| Maximum | 901 |
| Zeros | 34 |
| Zeros (%) | 0.4% |
| Memory size | 35.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 29 |
| Q1 | 56 |
| median | 81 |
| Q3 | 104 |
| 95-th percentile | 159 |
| Maximum | 901 |
| Range | 901 |
| Interquartile range (IQR) | 48 |
Descriptive statistics
| Standard deviation | 42.85129212 |
|---|---|
| Coefficient of variation (CV) | 0.5038097973 |
| Kurtosis | 18.40884244 |
| Mean | 85.05450341 |
| Median Absolute Deviation (MAD) | 24 |
| Skewness | 2.139015977 |
| Sum | 772465 |
| Variance | 1836.233237 |
| Value | Count | Frequency (%) | |
| 81 | 184 | 2.0% | |
| 77 | 136 | 1.5% | |
| 78 | 135 | 1.5% | |
| 82 | 131 | 1.4% | |
| 83 | 131 | 1.4% | |
| 80 | 125 | 1.4% | |
| 84 | 124 | 1.4% | |
| 79 | 124 | 1.4% | |
| 75 | 120 | 1.3% | |
| 85 | 117 | 1.3% | |
| Other values (267) | 7755 | 85.4% |
| Value | Count | Frequency (%) | |
| 0 | 34 | 0.4% | |
| 1 | 4 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% | |
| 5 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 901 | 1 | < 0.1% | |
| 323 | 1 | < 0.1% | |
| 317 | 1 | < 0.1% | |
| 314 | 2 | < 0.1% | |
| 313 | 1 | < 0.1% |
Staff Weekly Confirmed COVID-19
Categorical
| Distinct count | 47 |
|---|---|
| Unique (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 71.0 KiB |
| 0 | |
|---|---|
| 1 | 1251 |
| 2 | 456 |
| 3 | 237 |
| 4 | 98 |
| Other values (42) | 332 |
| Value | Count | Frequency (%) | |
| 0 | 6708 | 73.9% | |
| 1 | 1251 | 13.8% | |
| 2 | 456 | 5.0% | |
| 3 | 237 | 2.6% | |
| 4 | 98 | 1.1% | |
| 6 | 55 | 0.6% | |
| 5 | 51 | 0.6% | |
| 7 | 36 | 0.4% | |
| 8 | 31 | 0.3% | |
| 9 | 19 | 0.2% | |
| Other values (37) | 140 | 1.5% |
Length
| Max length | 2 |
|---|---|
| Median length | 1 |
| Mean length | 1.015415107 |
| Min length | 1 |
| Distinct count | 118 |
|---|---|
| Unique (%) | 1.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.67022682228584 |
|---|---|
| Minimum | 0 |
| Maximum | 130 |
| Zeros | 827 |
| Zeros (%) | 9.1% |
| Memory size | 35.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 4 |
| median | 15 |
| Q3 | 31 |
| 95-th percentile | 60 |
| Maximum | 130 |
| Range | 130 |
| Interquartile range (IQR) | 27 |
Descriptive statistics
| Standard deviation | 20.46763429 |
|---|---|
| Coefficient of variation (CV) | 0.990198824 |
| Kurtosis | 3.471336276 |
| Mean | 20.67022682 |
| Median Absolute Deviation (MAD) | 12 |
| Skewness | 1.597035582 |
| Sum | 187727 |
| Variance | 418.9240534 |
| Value | Count | Frequency (%) | |
| 0 | 827 | 9.1% | |
| 1 | 536 | 5.9% | |
| 2 | 378 | 4.2% | |
| 3 | 329 | 3.6% | |
| 5 | 281 | 3.1% | |
| 4 | 274 | 3.0% | |
| 8 | 272 | 3.0% | |
| 23 | 220 | 2.4% | |
| 14 | 218 | 2.4% | |
| 15 | 216 | 2.4% | |
| Other values (108) | 5531 | 60.9% |
| Value | Count | Frequency (%) | |
| 0 | 827 | 9.1% | |
| 1 | 536 | 5.9% | |
| 2 | 378 | 4.2% | |
| 3 | 329 | 3.6% | |
| 4 | 274 | 3.0% |
| Value | Count | Frequency (%) | |
| 130 | 5 | 0.1% | |
| 126 | 1 | < 0.1% | |
| 123 | 1 | < 0.1% | |
| 117 | 7 | 0.1% | |
| 116 | 11 | 0.1% |
| Distinct count | 36 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.2176833296630698 |
|---|---|
| Minimum | 0 |
| Maximum | 53 |
| Zeros | 8549 |
| Zeros (%) | 94.1% |
| Memory size | 35.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 53 |
| Range | 53 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.908507433 |
|---|---|
| Coefficient of variation (CV) | 8.767356859 |
| Kurtosis | 336.3682511 |
| Mean | 0.2176833297 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 16.69552629 |
| Sum | 1977 |
| Variance | 3.642400623 |
| Value | Count | Frequency (%) | |
| 0 | 8549 | 94.1% | |
| 1 | 284 | 3.1% | |
| 2 | 108 | 1.2% | |
| 3 | 41 | 0.5% | |
| 4 | 22 | 0.2% | |
| 5 | 10 | 0.1% | |
| 6 | 9 | 0.1% | |
| 8 | 7 | 0.1% | |
| 10 | 5 | 0.1% | |
| 7 | 4 | < 0.1% | |
| Other values (26) | 43 | 0.5% |
| Value | Count | Frequency (%) | |
| 0 | 8549 | 94.1% | |
| 1 | 284 | 3.1% | |
| 2 | 108 | 1.2% | |
| 3 | 41 | 0.5% | |
| 4 | 22 | 0.2% |
| Value | Count | Frequency (%) | |
| 53 | 2 | < 0.1% | |
| 48 | 1 | < 0.1% | |
| 42 | 1 | < 0.1% | |
| 41 | 1 | < 0.1% | |
| 39 | 1 | < 0.1% |
| Distinct count | 68 |
|---|---|
| Unique (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.109997797841885 |
|---|---|
| Minimum | 0 |
| Maximum | 80 |
| Zeros | 2797 |
| Zeros (%) | 30.8% |
| Memory size | 35.5 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 2 |
| Q3 | 10 |
| 95-th percentile | 36 |
| Maximum | 80 |
| Range | 80 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 13.26590612 |
|---|---|
| Coefficient of variation (CV) | 1.635747191 |
| Kurtosis | 6.024255523 |
| Mean | 8.109997798 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 2.412339573 |
| Sum | 73655 |
| Variance | 175.9842652 |
| Value | Count | Frequency (%) | |
| 0 | 2797 | 30.8% | |
| 1 | 1051 | 11.6% | |
| 2 | 879 | 9.7% | |
| 3 | 632 | 7.0% | |
| 5 | 330 | 3.6% | |
| 10 | 271 | 3.0% | |
| 4 | 268 | 3.0% | |
| 6 | 211 | 2.3% | |
| 8 | 205 | 2.3% | |
| 9 | 201 | 2.2% | |
| Other values (58) | 2237 | 24.6% |
| Value | Count | Frequency (%) | |
| 0 | 2797 | 30.8% | |
| 1 | 1051 | 11.6% | |
| 2 | 879 | 9.7% | |
| 3 | 632 | 7.0% | |
| 4 | 268 | 3.0% |
| Value | Count | Frequency (%) | |
| 80 | 17 | 0.2% | |
| 68 | 17 | 0.2% | |
| 66 | 19 | 0.2% | |
| 65 | 1 | < 0.1% | |
| 63 | 18 | 0.2% |
Staff Total COVID-19 Deaths
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 35.5 KiB |
| 0 | |
|---|---|
| 1 | 534 |
| 2 | 43 |
| Value | Count | Frequency (%) | |
| 0 | 8505 | 93.6% | |
| 1 | 534 | 5.9% | |
| 2 | 43 | 0.5% |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Shortage of Nursing Staff
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 71.0 KiB |
| N | |
|---|---|
| Y | 508 |
| Value | Count | Frequency (%) | |
| N | 8574 | 94.4% | |
| Y | 508 | 5.6% |
Shortage of Clinical Staff
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 71.0 KiB |
| N | |
|---|---|
| Y | 202 |
| Value | Count | Frequency (%) | |
| N | 8880 | 97.8% | |
| Y | 202 | 2.2% |
Shortage of Aides
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 71.0 KiB |
| N | |
|---|---|
| Y | 551 |
| Value | Count | Frequency (%) | |
| N | 8531 | 93.9% | |
| Y | 551 | 6.1% |
Shortage of Other Staff
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 71.0 KiB |
| N | |
|---|---|
| Y | 280 |
| Value | Count | Frequency (%) | |
| N | 8802 | 96.9% | |
| Y | 280 | 3.1% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 71.0 KiB |
| Y | |
|---|---|
| N | 412 |
| Value | Count | Frequency (%) | |
| Y | 8670 | 95.5% | |
| N | 412 | 4.5% |
One-Week Supply of N95 Masks
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 71.0 KiB |
| Y | |
|---|---|
| N | 1285 |
| Value | Count | Frequency (%) | |
| Y | 7797 | 85.9% | |
| N | 1285 | 14.1% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 71.0 KiB |
| Y | |
|---|---|
| N | 401 |
| Value | Count | Frequency (%) | |
| Y | 8681 | 95.6% | |
| N | 401 | 4.4% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 71.0 KiB |
| Y | |
|---|---|
| N | 464 |
| Value | Count | Frequency (%) | |
| Y | 8618 | 94.9% | |
| N | 464 | 5.1% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 71.0 KiB |
| Y | |
|---|---|
| N | 400 |
| Value | Count | Frequency (%) | |
| Y | 8682 | 95.6% | |
| N | 400 | 4.4% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 71.0 KiB |
| Y | |
|---|---|
| N | 444 |
| Value | Count | Frequency (%) | |
| Y | 8638 | 95.1% | |
| N | 444 | 4.9% |
One-Week Supply of Gowns
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 71.0 KiB |
| Y | |
|---|---|
| N | 702 |
| Value | Count | Frequency (%) | |
| Y | 8380 | 92.3% | |
| N | 702 | 7.7% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 71.0 KiB |
| Y | |
|---|---|
| N | 57 |
| Value | Count | Frequency (%) | |
| Y | 9025 | 99.4% | |
| N | 57 | 0.6% |
Three or More Confirmed COVID-19 Cases This Week or Initial Confirmed COVID-19 Case this Week
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 71.0 KiB |
| N | |
|---|---|
| Y | 563 |
| Value | Count | Frequency (%) | |
| N | 8519 | 93.8% | |
| Y | 563 | 6.2% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 71.0 KiB |
| Y | |
|---|---|
| N | 22 |
| Value | Count | Frequency (%) | |
| Y | 9060 | 99.8% | |
| N | 22 | 0.2% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| Week Ending | Provider Name | Provider City | Residents Total Admissions COVID-19 | Residents Total Confirmed COVID-19 | Residents Total Suspected COVID-19 | Residents Weekly All Deaths | Residents Total All Deaths | Residents Total COVID-19 Deaths | Number of All Beds | Total Number of Occupied Beds | Staff Weekly Confirmed COVID-19 | Staff Total Confirmed COVID-19 | Staff Weekly Suspected COVID-19 | Staff Total Suspected COVID-19 | Staff Total COVID-19 Deaths | Shortage of Nursing Staff | Shortage of Clinical Staff | Shortage of Aides | Shortage of Other Staff | Any Current Supply of N95 Masks | One-Week Supply of N95 Masks | Any Current Supply of Surgical Masks | One-Week Supply of Surgical Masks | Any Current Supply of Eye Protection | One-Week Supply of Eye Protection | One-Week Supply of Gowns | Any Current Supply of Hand Sanitizer | Three or More Confirmed COVID-19 Cases This Week or Initial Confirmed COVID-19 Case this Week | Able to Test or Obtain Resources to Test All Current Residents Within Next 7 Days | Able to Test or Obtain Resources to Test All Staff and/or Personnel Within Next 7 Days | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2020-05-24T00:00:00 | NORTHBRIDGE HEALTH CARE CENTER | BRIDGEPORT | 25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | N | N | N | N | Y | Y | Y | Y | Y | Y | Y | Y | N | Y | Y |
| 1 | 2020-05-24T00:00:00 | ORCHARD GROVE SPECIALTY CARE CENTER, LLC | UNCASVILLE | 6 | 28 | 3 | 0 | 19 | 7 | 120 | 81 | 0 | 15 | 0 | 2 | 0 | N | N | N | N | Y | Y | Y | Y | Y | Y | Y | Y | N | Y | Y |
| 2 | 2020-07-19T00:00:00 | WATROUS NURSING CENTER | MADISON | 0 | 1 | 1 | 0 | 0 | 0 | 45 | 29 | 0 | 1 | 0 | 0 | 0 | N | N | N | N | Y | Y | Y | Y | Y | Y | Y | Y | N | Y | Y |
| 3 | 2020-06-28T00:00:00 | APPLE REHAB SHELTON LAKES | SHELTON | 1 | 0 | 0 | 1 | 2 | 0 | 106 | 73 | 0 | 0 | 0 | 0 | 0 | N | N | N | N | Y | Y | Y | Y | Y | Y | Y | Y | N | Y | Y |
| 4 | 2020-09-13T00:00:00 | REGALCARE AT GREENWICH | GREENWICH | 11 | 12 | 0 | 0 | 28 | 14 | 75 | 62 | 0 | 7 | 0 | 0 | 0 | N | N | N | N | Y | Y | Y | Y | Y | Y | Y | Y | N | Y | Y |
| 5 | 2020-11-15T00:00:00 | WITHERELL, NATHANIEL | GREENWICH | 161 | 30 | 14 | 0 | 16 | 16 | 202 | 152 | 1 | 11 | 0 | 0 | 0 | N | N | N | N | Y | Y | Y | Y | Y | Y | Y | Y | N | Y | Y |
| 6 | 2020-12-27T00:00:00 | AVERY NURSING HOME | HARTFORD | 25 | 82 | 1 | 1 | 39 | 21 | 199 | 141 | 1 | 92 | 0 | 11 | 0 | N | N | N | N | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y |
| 7 | 2020-08-30T00:00:00 | REGALCARE AT GREENWICH | GREENWICH | 11 | 12 | 0 | 0 | 28 | 14 | 75 | 64 | 0 | 7 | 0 | 0 | 0 | N | N | N | N | Y | Y | Y | Y | Y | Y | Y | Y | N | Y | Y |
| 8 | 2020-10-11T00:00:00 | GROVE MANOR NURSING HOME, INC | WATERBURY | 2 | 29 | 0 | 0 | 2 | 1 | 60 | 43 | 1 | 7 | 0 | 0 | 0 | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | N | Y | Y |
| 9 | 2021-01-31T00:00:00 | WINDSOR HEALTH AND REHABILITATION CENTER, LLC | WINDSOR | 7 | 8 | 1 | 0 | 34 | 0 | 108 | 88 | 0 | 18 | 0 | 0 | 0 | Y | N | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | N | Y | Y |
Last rows
| Week Ending | Provider Name | Provider City | Residents Total Admissions COVID-19 | Residents Total Confirmed COVID-19 | Residents Total Suspected COVID-19 | Residents Weekly All Deaths | Residents Total All Deaths | Residents Total COVID-19 Deaths | Number of All Beds | Total Number of Occupied Beds | Staff Weekly Confirmed COVID-19 | Staff Total Confirmed COVID-19 | Staff Weekly Suspected COVID-19 | Staff Total Suspected COVID-19 | Staff Total COVID-19 Deaths | Shortage of Nursing Staff | Shortage of Clinical Staff | Shortage of Aides | Shortage of Other Staff | Any Current Supply of N95 Masks | One-Week Supply of N95 Masks | Any Current Supply of Surgical Masks | One-Week Supply of Surgical Masks | Any Current Supply of Eye Protection | One-Week Supply of Eye Protection | One-Week Supply of Gowns | Any Current Supply of Hand Sanitizer | Three or More Confirmed COVID-19 Cases This Week or Initial Confirmed COVID-19 Case this Week | Able to Test or Obtain Resources to Test All Current Residents Within Next 7 Days | Able to Test or Obtain Resources to Test All Staff and/or Personnel Within Next 7 Days | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9072 | 2020-08-16T00:00:00 | SOUTHINGTON CARE CENTER | SOUTHINGTON | 14 | 59 | 12 | 1 | 15 | 9 | 130 | 97 | 0 | 31 | 0 | 9 | 0 | N | N | N | N | Y | Y | Y | Y | Y | Y | Y | Y | N | Y | Y |
| 9073 | 2021-01-17T00:00:00 | APPLE REHAB COLCHESTER | COLCHESTER | 0 | 45 | 0 | 0 | 4 | 2 | 60 | 37 | 0 | 33 | 0 | 0 | 0 | N | N | N | N | Y | Y | Y | Y | Y | Y | Y | Y | N | Y | Y |
| 9074 | 2020-07-12T00:00:00 | AVON HEALTH CENTER | AVON | 5 | 50 | 75 | 0 | 32 | 7 | 120 | 92 | 0 | 12 | 0 | 32 | 0 | N | N | N | N | Y | Y | Y | Y | Y | Y | Y | Y | N | Y | Y |
| 9075 | 2020-12-20T00:00:00 | TOUCHPOINTS AT BLOOMFIELD | BLOOMFIELD | 64 | 102 | 2 | 0 | 20 | 15 | 150 | 118 | 0 | 21 | 0 | 59 | 1 | N | N | N | N | Y | N | Y | Y | Y | Y | Y | Y | N | Y | Y |
| 9076 | 2020-11-01T00:00:00 | WATROUS NURSING CENTER | MADISON | 0 | 1 | 1 | 0 | 0 | 0 | 45 | 27 | 0 | 1 | 0 | 0 | 0 | N | N | N | N | Y | Y | Y | Y | Y | Y | Y | Y | N | Y | Y |
| 9077 | 2020-08-23T00:00:00 | NOTRE DAME CONVALESCENT HOME I | NORWALK | 3 | 22 | 38 | 0 | 17 | 13 | 60 | 45 | 0 | 20 | 0 | 13 | 0 | N | N | N | N | Y | Y | Y | Y | Y | Y | Y | Y | N | Y | Y |
| 9078 | 2021-01-24T00:00:00 | LEDGECREST HEALTH CARE | KENSINGTON | 6 | 26 | 1 | 0 | 15 | 5 | 55 | 48 | 0 | 12 | 0 | 0 | 0 | N | N | N | N | Y | Y | Y | Y | Y | Y | Y | Y | N | Y | Y |
| 9079 | 2021-01-31T00:00:00 | JOHN L. LEVITOW HEALTH CARE CENTER | ROCKY HILL | 12 | 34 | 0 | 0 | 20 | 7 | 125 | 81 | 2 | 42 | 0 | 3 | 0 | N | N | N | N | Y | Y | Y | Y | Y | Y | Y | Y | N | Y | Y |
| 9080 | 2020-12-06T00:00:00 | APPLE REHAB SHELTON LAKES | SHELTON | 8 | 21 | 0 | 1 | 10 | 0 | 106 | 79 | 2 | 4 | 0 | 0 | 0 | N | N | N | N | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y |
| 9081 | 2020-08-23T00:00:00 | BETHEL HEALTH CARE CENTER | BETHEL | 23 | 61 | 66 | 0 | 44 | 16 | 161 | 119 | 0 | 30 | 0 | 19 | 1 | N | N | N | N | Y | Y | Y | Y | Y | Y | Y | Y | N | Y | Y |